Release 10.1A: OpenEdge Data Management:
SQL Reference

DROP SEQUENCE

The DROP SEQUENCE Statement removes a sequence from a schema. You must have Database Administration privileges to remove a sequence.

Use the following syntax to remove a sequence:

Syntax

DROP SEQUENCE [schema_name.]sequence_name

schema_name

Specifies the schema name that contains the sequence. If this is not specified, OpenEdge SQL drops the sequence, if present, from the current schema.

sequence_name

Specifies the sequence to be dropped.

In the following example, a sequence named customer is dropped from the public (PUB):

Example

DROP SEQUENCE pub.customer